<%@ page language="java" import="java.util.*,com.entity.*" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://jsptags.com/tags/navigation/pager" prefix="pg" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/functions"  prefix="fn"%>

 <%    
response.setContentType("application/xls");    
response.setHeader("Content-Disposition", "inline; filename=\"test.xls\"");    
%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" " http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns=" http://www.w3.org/1999/xhtml">

  <head>
   	<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
	<meta http-equiv="pragma" content="no-cache"/>
	<meta http-equiv="cache-control" content="no-cache"/>
	<meta http-equiv="expires" content="0"/>    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3"/>
	<meta http-equiv="description" content="This is my page"/>
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css"/>
	-->
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<script src="js/sorttable.js"></script>
<script src="js/main.js"></script>
<script src="js/qy.js"></script>
  </head>
   
  <body>
<table border="0" width="100%">
  <tr>
     <td align="left">填表单位:</td>
     <td width="20%"></td>
     <td align="left">负责人签字：</td>
     <td width="20%"></td>
     <td align="center">联系电话：</td>
     <td width="20%" align="center"></td>
  </tr>
<table class="TableTop" width="100%" >
  <tbody><tr>
      <td class="left"></td>
      <td class="center subject">专业技术岗位首聘核准情况统计</td>
      <td class="right"></td>
   </tr>
</tbody></table>
<table width="100%" border="1" cellpadding="0" cellspacing="0" class="TableBlock no-top-border">
  <tr>
    <td align="center" class="TableData" width="30px" colspan="2">单位全称</td>
    <td align="center" class="TableData"  colspan="4">&nbsp;</td>
    <td align="center" class="TableData"  colspan="2">经费形式</td>
    <td align="center" class="TableData"  colspan="2">&nbsp;</td>
    <td align="center" class="TableData"  colspan="2">编制人数</td>
    <td align="center" class="TableData"  colspan="2">&nbsp;</td>
    <td align="center" class="TableData"  rowspan="4" width="20px">单位意见</td>
    <td align="center" class="TableData"  rowspan="4" width="150px">
       <div style="float: right;margin-top: 80%">&nbsp;&nbsp;&nbsp;<br/><br/><br/>&nbsp;&nbsp;年&nbsp;&nbsp;&nbsp;月&nbsp;&nbsp;&nbsp;日</div>
    </td>
  </tr>
  <tr >
    <td align="center" class="TableData"  colspan="2">批准时间及文号</td>
    <td align="center" class="TableData"  colspan="3">&nbsp;</td>
    <td align="center" class="TableData" >单位类型</td>
    <td align="center" class="TableData"  colspan="3">&nbsp;</td>
    <td align="center" class="TableData">现有人数</td>
    <td align="center" class="TableData"  >&nbsp;</td>
    <td align="center" class="TableData" width="30px" colspan="2">专业技术人员岗位设置数</td>
    <td align="center" class="TableData"  >&nbsp;</td>
  </tr>
  <tr>
    <td align="center" class="TableData" rowspan="6">专业技术人员设置情况</td>
    <td align="center" class="TableData" >级别</td>
    <td align="center" class="TableData"  colspan="3">正高级</td>
    <td align="center" class="TableData"  colspan="3">副高级</td>
    <td align="center" class="TableData"  colspan="3">中级</td>
    <td align="center" class="TableData"  colspan="3">初级</td>
  </tr>
  <tr>
    <td  align="center" class="TableData">比例</td>
    <td align="center" class="TableData"  colspan="3">&nbsp;</td>
    <td align="center" class="TableData"  colspan="3">&nbsp;</td>
    <td align="center" class="TableData"  colspan="3">&nbsp;</td>
    <td align="center" class="TableData"  colspan="3">&nbsp;</td>
  </tr>
  <tr  >
    <td align="center" class="TableData" >岗位数</td>
    <td  align="center" class="TableData" colspan="3">&nbsp;</td>
    <td  align="center" class="TableData" colspan="3">&nbsp;</td>
    <td  align="center" class="TableData" colspan="3">&nbsp;</td>
    <td align="center" class="TableData"  colspan="3">13</td>
    <td  align="center" class="TableData" rowspan="4">主管部门审核意见</td>
    <td align="center" class="TableData"  rowspan="4" width="150px">
     <div style="float: right;margin-top: 80%">&nbsp;&nbsp;&nbsp;<br/><br/><br/>&nbsp;&nbsp;年&nbsp;&nbsp;&nbsp;月&nbsp;&nbsp;&nbsp;日</div>
    </td>
  </tr>
  <tr >
    <td align="center" class="TableData">等级</td>
    <td  align="center" class="TableData">二级</td>
    <td align="center" class="TableData" >三级</td>
    <td  align="center" class="TableData" >四级</td>
    <td align="center" class="TableData" >五级</td>
    <td align="center" class="TableData" >六级</td>
    <td  align="center" class="TableData" >七级</td>
    <td  align="center" class="TableData" >八级</td>
    <td align="center" class="TableData" >九级</td>
    <td align="center" class="TableData" >十级</td>
    <td  align="center" class="TableData" >十一级</td>
    <td  align="center" class="TableData" >十二级</td>
    <td align="center" class="TableData" >十三级</td>
  </tr>
  <tr  >
    
    <td align="center" class="TableData" >比例</td>
    <c:if test="${fn:length(list)!=0}">
    <c:forEach var="l" items="${list}">
    <td align="center" class="TableData" ><c:if test="${l.erji!=0}">${l.erji}</c:if></td>
    <td align="center" class="TableData" ><c:if test="${l.sanji!=0}">${l.sanji}</c:if></td>
    <td align="center" class="TableData" ><c:if test="${l.siji!=0}">${l.siji}</c:if></td>
    <td align="center" class="TableData" ><c:if test="${l.wuji!=0}">${l.wuji}</c:if></td>
    <td align="center" class="TableData" ><c:if test="${l.liuji!=0}">${l.liuji}</c:if></td>
    <td align="center" class="TableData" ><c:if test="${l.qiji!=0}">${l.qiji}</c:if></td>
    <td align="center" class="TableData" ><c:if test="${l.baji!=0}">${l.baji}</c:if></td>
    <td align="center" class="TableData" ><c:if test="${l.jiuji!=0}">${l.jiuji}</c:if></td>
    <td align="center" class="TableData" ><c:if test="${l.shiji!=0}">${l.shiji}</c:if></td>
    <td align="center" class="TableData" ><c:if test="${l.shiyiji!=0}">${l.shiyiji}</c:if></td>
    <td align="center" class="TableData" ><c:if test="${l.shierji!=0}">${l.shierji}</c:if></td>
    <td align="center" class="TableData" ><c:if test="${l.shisanji!=0}">${l.shisanji}</c:if></td>
    </c:forEach>
    </c:if>
    <c:if test="${fn:length(list)==0}">
       <td align="center" class="TableData"> &nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    </c:if>
  </tr>
 <tr >
    <td align="center" class="TableData" >岗位数</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
    <td align="center" class="TableData" >&nbsp;</td>
  </tr>
  <tr>
    <td align="center" class="TableData" rowspan="10">现各系列专业设置情况</td>
     <c:if test="${fn:length(list1)>0}">
    <td colspan="13" align="center" class="TableData">
	    <table border="1" width="100%" cellpadding="0" cellspacing="0" class="TableBlock no-top-border">
	       <c:forEach var="r" items="${list1}">
		    <tr>
		        <td width="40px" align="center" class="TableData">${r.zy }</td>
			    <td align="center" class="TableData" ><c:if test="${r.erji1!=0 }">${r.erji1}</c:if></td>
			    <td align="center" class="TableData" ><c:if test="${r.sanji1!=0 }">${r.sanji1}</c:if></td>
			    <td align="center" class="TableData" ><c:if test="${r.siji1!=0}"> ${r.siji1 }</c:if></td>
			    <td align="center" class="TableData" ><c:if test="${r.wuji1!=0}"> ${r.wuji1 }</c:if></td>
			    <td align="center" class="TableData" ><c:if test="${r.liuji1!=0}"> ${r.liuji1 }</c:if></td>
			    <td align="center" class="TableData" ><c:if test="${r.qiji1!=0}"> ${r.qiji1 }</c:if></td>
			    <td align="center" class="TableData" ><c:if test="${r.baji1!=0}"> ${r.baji1 }</c:if></td>
			    <td align="center" class="TableData" ><c:if test="${r.jiuji1!=0}"> ${r.jiuji1 }</c:if></td>
			    <td align="center" class="TableData" ><c:if test="${r.shiji1!=0}"> ${r.shiji1 }</c:if></td>
			    <td align="center" class="TableData" ><c:if test="${r.shiyiji1!=0}"> ${r.shiyiji1 }</c:if></td>
			    <td align="center" class="TableData" ><c:if test="${r.shierji1!=0}"> ${r.shierji1 }</c:if></td>
			    <td align="center" class="TableData" ><c:if test="${r.shisanji1!=0}"> ${r.shisanji1 }</c:if></td>
			    
		    </tr>
		   </c:forEach>
		</table>
	</td>
	</c:if>
	<%List list2 = (List)request.getAttribute("list2"); 
	   Iterator it =list2.iterator();
	 %>
	<c:if test="${fn:length(list1)==0}">
	<% 
	   while(it.hasNext()){
	   it.next();
	   System.out.println(it.next()+"123");
	%>
	<td align="center" class="TableData"><%=it.next() %></td>
    <td align="center" class="TableData">&nbsp;</td>
    <td align="center" class="TableData">&nbsp;</td>
    <td align="center" class="TableData">&nbsp;</td>
    <td align="center" class="TableData">&nbsp;</td>
    <td align="center" class="TableData">&nbsp;</td>
    <td align="center" class="TableData">&nbsp;</td>
    <td align="center" class="TableData">&nbsp;</td>
    <td align="center" class="TableData">&nbsp;</td>
    <td align="center" class="TableData">&nbsp;</td>
    <td align="center" class="TableData">&nbsp;</td>
    <td align="center" class="TableData">&nbsp;</td>
    <td align="center" class="TableData">&nbsp;</td>
  <%} %>
	</c:if>
    <td align="center" class="TableData" rowspan="10">区职改办审核意见</td>
    <td align="center" class="TableData" rowspan="10" width="150px">
       <div style="float: right;margin-top: 85%">&nbsp;&nbsp;&nbsp;<br/><br/><br/>&nbsp;&nbsp;年&nbsp;&nbsp;&nbsp;月&nbsp;&nbsp;&nbsp;日</div>
    </td>
  </tr>
 
</table>

  
  </body>
</html>